Insert Grand Total dialog box

This dialog box appears when:

Use the Insert Grand Total dialog box to select the kind of grand total you want to appear on your report.

Note:    You cannot sum or average a text, Boolean, or date field.

Summary Function

Select the summary function that you want to use for the grand total.

Show as a percentage of

Select this check box if you want to calculate the percentage total of one group within a broader grouping. For example, you could calculate a Grand Total of each employee's yearly sales, and then display the results as a percentage of Last Year's Sales for the entire company.

After you select the check box, you can choose the total or group you want the comparison to be based on.

Note:    The percentage option is available only when the result of a summary operation is numeric.

Sum across hierarchy

This option enables you to calculate a grand total across hierarchical groupings. To set or edit Hierarchical Options for existing groups, click Hierarchical Grouping Options on the Report menu. For details, see Grouping data hierarchically.

Related topics

Grand Total command

Using the Grand Total command



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com